package com.kaka.mapper;

import com.kaka.pojo.Emp;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface EmpMapper {

    /*@Select("select count(*) from tb_emp")
    public Long count();

    @Select("select * from tb_emp limit #{start},#{pageSize}")
    public List<Emp> page(Integer start, Integer pageSize);*/

    //@Select("select * from tb_emp")
    public List<Emp> page(String name, Short gender, LocalDate begin, LocalDate end);

    void delete(Integer[] ids);

    void insert(Emp emp);

    @Select("select * from tb_emp where id = #{id}")
    Emp selectById(Integer id);

    void update(Emp emp);

    @Select("select * from tb_emp where username = #{username} and password = #{password}")
    Emp getByUsernameAndPassword(Emp emp);

    @Delete("delete from tb_emp where id = #{id}")
    void deleteById(Integer id);
}
